Dataset info
| Number of variables | 56 |
|---|---|
| Number of observations | 85273 |
| Missing cells | 432054 (9.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 36.4 MiB |
| Average record size in memory | 448.0 B |
Variables types
| Numeric | 25 |
|---|---|
| Categorical | 19 |
| Boolean | 8 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 4 |
| Unsupported | 0 |
Warnings
amenities has a high cardinality: 74989 distinct values | Warning |
availability_30 has 39823 (46.7%) zeros | Zeros |
availability_365 has 28858 (33.8%) zeros | Zeros |
availability_60 is highly correlated with availability_30 (ρ = 0.9406128974) | Rejected |
availability_90 is highly correlated with availability_60 (ρ = 0.9777661242) | Rejected |
bedrooms has 5144 (6.0%) zeros | Zeros |
beds has 2090 (2.5%) zeros | Zeros |
calculated_host_listings_count_entire_homes is highly correlated with calculated_host_listings_count (ρ = 0.9960387541) | Rejected |
calculated_host_listings_count_private_rooms has 41260 (48.4%) zeros | Zeros |
calculated_host_listings_count_shared_rooms has 84247 (98.8%) zeros | Zeros |
cleaning_fee has a high cardinality: 259 distinct values | Warning |
cleaning_fee has 21530 (25.2%) missing values | Missing |
extra_people has a high cardinality: 114 distinct values | Warning |
first_review has a high cardinality: 2759 distinct values | Warning |
first_review has 21004 (24.6%) missing values | Missing |
host_since has a high cardinality: 3418 distinct values | Warning |
host_verifications has a high cardinality: 548 distinct values | Warning |
id is highly correlated with df_index (ρ = 0.9932492122) | Rejected |
last_review has a high cardinality: 1779 distinct values | Warning |
last_review has 21004 (24.6%) missing values | Missing |
last_scraped only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
maximum_nights is highly skewed (γ1 = 229.4506278) | Skewed |
minimum_nights is highly skewed (γ1 = 31.59665823) | Skewed |
monthly_price has a high cardinality: 872 distinct values | Warning |
monthly_price has 80144 (94.0%) missing values | Missing |
neighbourhood has a high cardinality: 150 distinct values | Warning |
number_of_reviews has 21003 (24.6%) zeros | Zeros |
number_of_reviews_ltm has 35468 (41.6%) zeros | Zeros |
price has a high cardinality: 888 distinct values | Warning |
review_scores_accuracy has 22734 (26.7%) missing values | Missing |
review_scores_checkin has 22782 (26.7%) missing values | Missing |
review_scores_cleanliness has 22721 (26.6%) missing values | Missing |
review_scores_communication has 22727 (26.7%) missing values | Missing |
review_scores_location has 22781 (26.7%) missing values | Missing |
review_scores_rating has 22683 (26.6%) missing values | Missing |
review_scores_value has 22782 (26.7%) missing values | Missing |
reviews_per_month has 21004 (24.6%) missing values | Missing |
security_deposit has a high cardinality: 380 distinct values | Warning |
security_deposit has 29653 (34.8%) missing values | Missing |
weekly_price has a high cardinality: 690 distinct values | Warning |
weekly_price has 78082 (91.6%) missing values | Missing |
accommodates
Numeric
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.203407918 |
|---|---|
| Minimum | 1 |
| Maximum | 30 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 2 |
| Q3 | 4 |
| 95-th percentile | 7 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 2.024787146 |
|---|---|
| Coef of variation | 0.6320728417 |
| Kurtosis | 4.675330574 |
| Mean | 3.203407918 |
| MAD | 1.585941834 |
| Skewness | 1.705369612 |
| Sum | 273161 |
| Variance | 4.099762987 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=19)
| Value | Count | Frequency (%) | |
| 2 | 35777 | 42.0% | |
| 4 | 17026 | 20.0% | |
| 1 | 10608 | 12.4% | |
| 6 | 6899 | 8.1% | |
| 3 | 5851 | 6.9% | |
| 5 | 4033 | 4.7% | |
| 8 | 2106 | 2.5% | |
| 7 | 1374 | 1.6% | |
| 10 | 569 | 0.7% | |
| 9 | 448 | 0.5% | |
| Other values (8) | 581 | 0.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 10608 | 12.4% | |
| 2 | 35777 | 42.0% | |
| 3 | 5851 | 6.9% | |
| 4 | 17026 | 20.0% | |
| 5 | 4033 | 4.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 30 | 1 | < 0.1% | |
| 20 | 1 | < 0.1% | |
| 16 | 101 | 0.1% | |
| 15 | 24 | < 0.1% | |
| 14 | 90 | 0.1% |
amenities
Categorical
| Distinct count | 74989 |
|---|---|
| Unique (%) | 87.9% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| {} | 350 |
|---|---|
| {Wifi,Kitchen,Heating,Washer,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hot water","Bed linens"} | 71 |
| {TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron} | 58 |
| Other values (74985) |
| Value | Count | Frequency (%) | |
| {} | 350 | 0.4% | |
| {Wifi,Kitchen,Heating,Washer,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hot water","Bed linens"} | 71 | 0.1% | |
| {TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron} | 58 | 0.1% | |
| {Wifi,Kitchen,Elevator,Heating,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Hot water","Bed linens","Extra pillows and blankets",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed","Well-lit path to entrance"} | 55 | 0.1% | |
| {TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 54 | 0.1% | |
| {TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Heating,"Suitable for events",Washer,Dryer,"Smoke detector","First aid kit",Essentials,"Hair dryer"} | 52 | 0.1% | |
| {TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 45 | 0.1% | |
| {TV,"Cable TV",Wifi,"Air conditioning",Elevator,Heating,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Keypad,"Private living room","Hot water","Bed linens","Long term stays allowed"} | 43 | 0.1% | |
| {TV,Wifi,Kitchen,Elevator,"Family/kid friendly",Washer,Essentials,Hangers,"Laptop friendly workspace","Private living room",Microwave,Dishwasher,Oven} | 33 | < 0.1% | |
| {TV,Wifi,Kitchen,Heating,Washer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 31 | < 0.1% | |
| Other values (74978) | 84480 | 99.1% |
| Max length | 1546 |
|---|---|
| Mean length | 279.3795691 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
availability_30
Numeric
| Distinct count | 32 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.662609063 |
|---|---|
| Minimum | 0 |
| Maximum | 30 |
| Zeros (%) | 46.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 2 |
| Q3 | 14 |
| 95-th percentile | 29 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range | 14 |
Descriptive statistics
| Standard deviation | 10.07592017 |
|---|---|
| Coef of variation | 1.314946396 |
| Kurtosis | -0.259285516 |
| Mean | 7.662609063 |
| MAD | 8.487324182 |
| Skewness | 1.080498275 |
| Sum | 653406 |
| Variance | 101.5241672 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=32)
| Value | Count | Frequency (%) | |
| 0 | 39823 | 46.7% | |
| 30 | 3646 | 4.3% | |
| 29 | 2778 | 3.3% | |
| 1 | 2718 | 3.2% | |
| 2 | 2136 | 2.5% | |
| 3 | 2116 | 2.5% | |
| 4 | 1981 | 2.3% | |
| 5 | 1957 | 2.3% | |
| 14 | 1865 | 2.2% | |
| 6 | 1851 | 2.2% | |
| Other values (21) | 24401 | 28.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 39823 | 46.7% | |
| 1 | 2718 | 3.2% | |
| 2 | 2136 | 2.5% | |
| 3 | 2116 | 2.5% | |
| 4 | 1981 | 2.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 30 | 3646 | 4.3% | |
| 29 | 2778 | 3.3% | |
| 28 | 1509 | 1.8% | |
| 27 | 1035 | 1.2% | |
| 26 | 609 | 0.7% |
availability_365
Numeric
| Distinct count | 367 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 118.749613 |
|---|---|
| Minimum | 0 |
| Maximum | 365 |
| Zeros (%) | 33.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 61 |
| Q3 | 252 |
| 95-th percentile | 362 |
| Maximum | 365 |
| Range | 365 |
| Interquartile range | 252 |
Descriptive statistics
| Standard deviation | 134.7227721 |
|---|---|
| Coef of variation | 1.134511252 |
| Kurtosis | -1.085666103 |
| Mean | 118.749613 |
| MAD | 119.0344027 |
| Skewness | 0.7226800702 |
| Sum | 10126017 |
| Variance | 18150.22532 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 28858 | 33.8% | |
| 365 | 2177 | 2.6% | |
| 364 | 1272 | 1.5% | |
| 1 | 845 | 1.0% | |
| 89 | 680 | 0.8% | |
| 90 | 673 | 0.8% | |
| 363 | 625 | 0.7% | |
| 257 | 578 | 0.7% | |
| 179 | 510 | 0.6% | |
| 2 | 498 | 0.6% | |
| Other values (356) | 48556 | 56.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 28858 | 33.8% | |
| 1 | 845 | 1.0% | |
| 2 | 498 | 0.6% | |
| 3 | 492 | 0.6% | |
| 4 | 413 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 365 | 2177 | 2.6% | |
| 364 | 1272 | 1.5% | |
| 363 | 625 | 0.7% | |
| 362 | 348 | 0.4% | |
| 361 | 227 | 0.3% |
availability_60
Highly correlated
This variable is highly correlated with availability_30 and should be ignored for analysis
| Correlation | 0.9406128974 |
|---|
availability_90
Highly correlated
This variable is highly correlated with availability_60 and should be ignored for analysis
| Correlation | 0.9777661242 |
|---|
bathrooms
Numeric
| Distinct count | 25 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.2% |
| Missing (n) | 128 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.305655059 |
|---|---|
| Minimum | 0 |
| Maximum | 17 |
| Zeros (%) | 0.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1.5 |
| 95-th percentile | 2.5 |
| Maximum | 17 |
| Range | 17 |
| Interquartile range | 0.5 |
Descriptive statistics
| Standard deviation | 0.6147730607 |
|---|---|
| Coef of variation | 0.4708541176 |
| Kurtosis | 29.12022176 |
| Mean | 1.305655059 |
| MAD | 0.4410566209 |
| Skewness | 3.553439877 |
| Sum | 111170 |
| Variance | 0.3779459162 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=25)
| Value | Count | Frequency (%) | |
| 1 | 59361 | 69.6% | |
| 2 | 12306 | 14.4% | |
| 1.5 | 7879 | 9.2% | |
| 2.5 | 2426 | 2.8% | |
| 3 | 1436 | 1.7% | |
| 3.5 | 554 | 0.6% | |
| 0.5 | 301 | 0.4% | |
| 0 | 299 | 0.4% | |
| 4 | 264 | 0.3% | |
| 4.5 | 114 | 0.1% | |
| Other values (14) | 205 | 0.2% | |
| (Missing) | 128 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 299 | 0.4% | |
| 0.5 | 301 | 0.4% | |
| 1 | 59361 | 69.6% | |
| 1.5 | 7879 | 9.2% | |
| 2 | 12306 | 14.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 17 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10.5 | 1 | < 0.1% | |
| 10 | 23 | < 0.1% | |
| 9.5 | 1 | < 0.1% |
bed_type
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Real Bed | |
|---|---|
| Pull-out Sofa | 409 |
| Futon | 180 |
| Other values (2) | 108 |
| Value | Count | Frequency (%) | |
| Real Bed | 84575 | 99.2% | |
| Pull-out Sofa | 409 | 0.5% | |
| Futon | 180 | 0.2% | |
| Couch | 66 | 0.1% | |
| Airbed | 42 | < 0.1% | |
| (Missing) | 1 | < 0.1% |
| Max length | 13 |
|---|---|
| Mean length | 8.014283536 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
bedrooms
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.1% |
| Missing (n) | 43 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.417458641 |
|---|---|
| Minimum | 0 |
| Maximum | 22 |
| Zeros (%) | 6.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 22 |
| Range | 22 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.9227060843 |
|---|---|
| Coef of variation | 0.6509580297 |
| Kurtosis | 8.915098104 |
| Mean | 1.417458641 |
| MAD | 0.6927195819 |
| Skewness | 1.962186823 |
| Sum | 120810 |
| Variance | 0.851386518 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 1 | 53248 | 62.4% | |
| 2 | 17616 | 20.7% | |
| 3 | 5952 | 7.0% | |
| 0 | 5144 | 6.0% | |
| 4 | 2289 | 2.7% | |
| 5 | 722 | 0.8% | |
| 6 | 182 | 0.2% | |
| 7 | 49 | 0.1% | |
| 8 | 12 | < 0.1% | |
| 10 | 6 | < 0.1% | |
| Other values (5) | 10 | < 0.1% | |
| (Missing) | 43 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5144 | 6.0% | |
| 1 | 53248 | 62.4% | |
| 2 | 17616 | 20.7% | |
| 3 | 5952 | 7.0% | |
| 4 | 2289 | 2.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 22 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| 10 | 6 | < 0.1% |
beds
Numeric
| Distinct count | 23 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.2% |
| Missing (n) | 154 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.755894689 |
|---|---|
| Minimum | 0 |
| Maximum | 28 |
| Zeros (%) | 2.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 28 |
| Range | 28 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.278717353 |
|---|---|
| Coef of variation | 0.7282426227 |
| Kurtosis | 16.20577142 |
| Mean | 1.755894689 |
| MAD | 0.911683207 |
| Skewness | 2.798381894 |
| Sum | 149460 |
| Variance | 1.63511807 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=23)
| Value | Count | Frequency (%) | |
| 1 | 46476 | 54.5% | |
| 2 | 20662 | 24.2% | |
| 3 | 8667 | 10.2% | |
| 4 | 3998 | 4.7% | |
| 0 | 2090 | 2.5% | |
| 5 | 1623 | 1.9% | |
| 6 | 842 | 1.0% | |
| 7 | 325 | 0.4% | |
| 8 | 201 | 0.2% | |
| 10 | 75 | 0.1% | |
| Other values (12) | 160 | 0.2% | |
| (Missing) | 154 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2090 | 2.5% | |
| 1 | 46476 | 54.5% | |
| 2 | 20662 | 24.2% | |
| 3 | 8667 | 10.2% | |
| 4 | 3998 | 4.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 28 | 1 | < 0.1% | |
| 20 | 3 | < 0.1% | |
| 19 | 2 | < 0.1% | |
| 18 | 2 | < 0.1% | |
| 17 | 2 | < 0.1% |
calculated_host_listings_count
Numeric
| Distinct count | 86 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.93245145 |
|---|---|
| Minimum | 1 |
| Maximum | 1130 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 5 |
| 95-th percentile | 65 |
| Maximum | 1130 |
| Range | 1129 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 131.0934511 |
|---|---|
| Coef of variation | 5.257944706 |
| Kurtosis | 63.96747936 |
| Mean | 24.93245145 |
| MAD | 38.95463532 |
| Skewness | 7.971575249 |
| Sum | 2126040 |
| Variance | 17185.49292 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1 | 43850 | 51.4% | |
| 2 | 12034 | 14.1% | |
| 3 | 4968 | 5.8% | |
| 4 | 2924 | 3.4% | |
| 5 | 1795 | 2.1% | |
| 6 | 1422 | 1.7% | |
| 7 | 1148 | 1.3% | |
| 1130 | 1130 | 1.3% | |
| 8 | 832 | 1.0% | |
| 9 | 729 | 0.9% | |
| Other values (75) | 14440 | 16.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 43850 | 51.4% | |
| 2 | 12034 | 14.1% | |
| 3 | 4968 | 5.8% | |
| 4 | 2924 | 3.4% | |
| 5 | 1795 | 2.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1130 | 1130 | 1.3% | |
| 227 | 227 | 0.3% | |
| 220 | 220 | 0.3% | |
| 196 | 196 | 0.2% | |
| 189 | 189 | 0.2% |
calculated_host_listings_count_entire_homes
Highly correlated
This variable is highly correlated with calculated_host_listings_count and should be ignored for analysis
| Correlation | 0.9960387541 |
|---|
calculated_host_listings_count_private_rooms
Numeric
| Distinct count | 38 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.915963036 |
|---|---|
| Minimum | 0 |
| Maximum | 135 |
| Zeros (%) | 48.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 6 |
| Maximum | 135 |
| Range | 135 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 7.988859935 |
|---|---|
| Coef of variation | 4.169631556 |
| Kurtosis | 167.7368941 |
| Mean | 1.915963036 |
| MAD | 2.412308529 |
| Skewness | 11.81047617 |
| Sum | 163378 |
| Variance | 63.82188307 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=38)
| Value | Count | Frequency (%) | |
| 0 | 41260 | 48.4% | |
| 1 | 25982 | 30.5% | |
| 2 | 6968 | 8.2% | |
| 3 | 3836 | 4.5% | |
| 4 | 1429 | 1.7% | |
| 5 | 1263 | 1.5% | |
| 6 | 600 | 0.7% | |
| 7 | 563 | 0.7% | |
| 10 | 358 | 0.4% | |
| 8 | 305 | 0.4% | |
| Other values (27) | 2708 | 3.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 41260 | 48.4% | |
| 1 | 25982 | 30.5% | |
| 2 | 6968 | 8.2% | |
| 3 | 3836 | 4.5% | |
| 4 | 1429 | 1.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 135 | 144 | 0.2% | |
| 96 | 101 | 0.1% | |
| 89 | 93 | 0.1% | |
| 41 | 73 | 0.1% | |
| 39 | 91 | 0.1% |
calculated_host_listings_count_shared_rooms
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.04647481002 |
|---|---|
| Minimum | 0 |
| Maximum | 18 |
| Zeros (%) | 98.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.6879514535 |
|---|---|
| Coef of variation | 14.80267382 |
| Kurtosis | 436.3144454 |
| Mean | 0.04647481002 |
| MAD | 0.0918323323 |
| Skewness | 19.93070147 |
| Sum | 3963 |
| Variance | 0.4732772024 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) | |
| 0 | 84247 | 98.8% | |
| 1 | 664 | 0.8% | |
| 12 | 56 | 0.1% | |
| 17 | 53 | 0.1% | |
| 2 | 45 | 0.1% | |
| 8 | 38 | < 0.1% | |
| 7 | 36 | < 0.1% | |
| 9 | 32 | < 0.1% | |
| 4 | 25 | < 0.1% | |
| 3 | 24 | < 0.1% | |
| Other values (3) | 52 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 84247 | 98.8% | |
| 1 | 664 | 0.8% | |
| 2 | 45 | 0.1% | |
| 3 | 24 | < 0.1% | |
| 4 | 25 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 18 | 22 | < 0.1% | |
| 17 | 53 | 0.1% | |
| 12 | 56 | 0.1% | |
| 10 | 11 | < 0.1% | |
| 9 | 32 | < 0.1% |
cancellation_policy
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| strict_14_with_grace_period | |
|---|---|
| flexible | |
| moderate | |
| Other values (5) | 870 |
| Value | Count | Frequency (%) | |
| strict_14_with_grace_period | 36612 | 42.9% | |
| flexible | 27738 | 32.5% | |
| moderate | 20052 | 23.5% | |
| super_strict_60 | 473 | 0.6% | |
| super_strict_30 | 366 | 0.4% | |
| luxury_moderate | 20 | < 0.1% | |
| strict | 8 | < 0.1% | |
| luxury_super_strict_95 | 3 | < 0.1% | |
| (Missing) | 1 | < 0.1% |
| Max length | 27 |
|---|---|
| Mean length | 16.22841931 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
cleaning_fee
Categorical
| Distinct count | 259 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 25.2% |
| Missing (n) | 21530 |
| $0.00 | 5938 |
|---|---|
| $20.00 | 5240 |
| $30.00 | 5104 |
| Other values (255) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| $0.00 | 5938 | 7.0% | |
| $20.00 | 5240 | 6.1% | |
| $30.00 | 5104 | 6.0% | |
| $10.00 | 4549 | 5.3% | |
| $50.00 | 3880 | 4.6% | |
| $15.00 | 3689 | 4.3% | |
| $40.00 | 3677 | 4.3% | |
| $25.00 | 3271 | 3.8% | |
| $60.00 | 2506 | 2.9% | |
| $35.00 | 1961 | 2.3% | |
| Other values (248) | 23928 | 28.1% | |
| (Missing) | 21530 | 25.2% |
| Max length | 9 |
|---|---|
| Mean length | 5.198315997 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
df_index
Numeric
| Distinct count | 85273 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 42636.95077 |
|---|---|
| Minimum | 0 |
| Maximum | 85273 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4264.6 |
| Q1 | 21319 |
| Median | 42637 |
| Q3 | 63955 |
| 95-th percentile | 81009.4 |
| Maximum | 85273 |
| Range | 85273 |
| Interquartile range | 42636 |
Descriptive statistics
| Standard deviation | 24616.42016 |
|---|---|
| Coef of variation | 0.577349452 |
| Kurtosis | -1.19998789 |
| Mean | 42636.95077 |
| MAD | 21318.29923 |
| Skewness | -1.028584916e-05 |
| Sum | 3635780703 |
| Variance | 605968141.6 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 85273.], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 27288 | 1 | < 0.1% | |
| 31386 | 1 | < 0.1% | |
| 29339 | 1 | < 0.1% | |
| 19100 | 1 | < 0.1% | |
| 17053 | 1 | < 0.1% | |
| 23198 | 1 | < 0.1% | |
| 21151 | 1 | < 0.1% | |
| 76464 | 1 | < 0.1% | |
| 74417 | 1 | < 0.1% | |
| Other values (85263) | 85263 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 85273 | 1 | < 0.1% | |
| 85272 | 1 | < 0.1% | |
| 85271 | 1 | < 0.1% | |
| 85270 | 1 | < 0.1% | |
| 85269 | 1 | < 0.1% |
experiences_offered
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| none | |
|---|---|
| business | 598 |
| family | 493 |
| Other values (2) | 642 |
| Value | Count | Frequency (%) | |
| none | 83540 | 98.0% | |
| business | 598 | 0.7% | |
| family | 493 | 0.6% | |
| social | 426 | 0.5% | |
| romantic | 216 | 0.3% |
| Max length | 8 |
|---|---|
| Mean length | 4.059737549 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
extra_people
Categorical
| Distinct count | 114 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| $0.00 | |
|---|---|
| $10.00 | 7915 |
| $15.00 | 6516 |
| Other values (110) |
| Value | Count | Frequency (%) | |
| $0.00 | 52172 | 61.2% | |
| $10.00 | 7915 | 9.3% | |
| $15.00 | 6516 | 7.6% | |
| $20.00 | 4851 | 5.7% | |
| $25.00 | 2285 | 2.7% | |
| $5.00 | 2270 | 2.7% | |
| $30.00 | 1698 | 2.0% | |
| $50.00 | 1072 | 1.3% | |
| $12.00 | 662 | 0.8% | |
| $35.00 | 641 | 0.8% | |
| Other values (103) | 5190 | 6.1% |
| Max length | 7 |
|---|---|
| Mean length | 5.344857106 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
first_review
Categorical
| Distinct count | 2759 |
|---|---|
| Unique (%) | 3.2% |
| Missing (%) | 24.6% |
| Missing (n) | 21004 |
| 2019-07-07 | 234 |
|---|---|
| 2019-01-01 | 222 |
| 2019-07-14 | 199 |
| Other values (2755) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 2019-07-07 | 234 | 0.3% | |
| 2019-01-01 | 222 | 0.3% | |
| 2019-07-14 | 199 | 0.2% | |
| 2019-06-30 | 196 | 0.2% | |
| 2019-06-02 | 185 | 0.2% | |
| 2019-08-11 | 176 | 0.2% | |
| 2019-01-02 | 170 | 0.2% | |
| 2019-08-04 | 162 | 0.2% | |
| 2019-04-28 | 162 | 0.2% | |
| 2019-06-16 | 161 | 0.2% | |
| Other values (2748) | 62402 | 73.2% | |
| (Missing) | 21004 | 24.6% |
| Max length | 10 |
|---|---|
| Mean length | 8.275796559 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
guests_included
Numeric
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.615113988 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.35578889 |
|---|---|
| Coef of variation | 0.8394385166 |
| Kurtosis | 15.30447086 |
| Mean | 1.615113988 |
| MAD | 0.8885653094 |
| Skewness | 3.30669013 |
| Sum | 137724 |
| Variance | 1.838163515 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) | |
| 1 | 61590 | 72.2% | |
| 2 | 12953 | 15.2% | |
| 4 | 5594 | 6.6% | |
| 3 | 1622 | 1.9% | |
| 6 | 1595 | 1.9% | |
| 5 | 874 | 1.0% | |
| 8 | 469 | 0.5% | |
| 7 | 251 | 0.3% | |
| 10 | 138 | 0.2% | |
| 9 | 74 | 0.1% | |
| Other values (6) | 112 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 61590 | 72.2% | |
| 2 | 12953 | 15.2% | |
| 3 | 1622 | 1.9% | |
| 4 | 5594 | 6.6% | |
| 5 | 874 | 1.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16 | 30 | < 0.1% | |
| 15 | 12 | < 0.1% | |
| 14 | 6 | < 0.1% | |
| 13 | 5 | < 0.1% | |
| 12 | 33 | < 0.1% |
host_has_profile_pic
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 17 |
| t | |
|---|---|
| f | 230 |
| (Missing) | 17 |
| Value | Count | Frequency (%) | |
| t | 85026 | 99.7% | |
| f | 230 | 0.3% | |
| (Missing) | 17 | < 0.1% |
host_identity_verified
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 17 |
| f | |
|---|---|
| t | |
| (Missing) | 17 |
| Value | Count | Frequency (%) | |
| f | 54698 | 64.1% | |
| t | 30558 | 35.8% | |
| (Missing) | 17 | < 0.1% |
host_is_superhost
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 17 |
| f | |
|---|---|
| t | 12515 |
| (Missing) | 17 |
| Value | Count | Frequency (%) | |
| f | 72741 | 85.3% | |
| t | 12515 | 14.7% | |
| (Missing) | 17 | < 0.1% |
host_since
Categorical
| Distinct count | 3418 |
|---|---|
| Unique (%) | 4.0% |
| Missing (%) | < 0.1% |
| Missing (n) | 16 |
| 2015-05-21 | 1164 |
|---|---|
| 2017-10-25 | 297 |
| 2015-03-05 | 266 |
| Other values (3414) |
| Value | Count | Frequency (%) | |
| 2015-05-21 | 1164 | 1.4% | |
| 2017-10-25 | 297 | 0.3% | |
| 2015-03-05 | 266 | 0.3% | |
| 2017-06-26 | 264 | 0.3% | |
| 2015-11-04 | 251 | 0.3% | |
| 2018-11-08 | 202 | 0.2% | |
| 2011-11-22 | 177 | 0.2% | |
| 2012-03-18 | 168 | 0.2% | |
| 2014-03-26 | 167 | 0.2% | |
| 2015-02-11 | 160 | 0.2% | |
| Other values (3407) | 82141 | 96.3% |
| Max length | 10 |
|---|---|
| Mean length | 9.998686571 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
host_verifications
Categorical
| Distinct count | 548 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| ['email', 'phone', 'reviews', 'jumio', 'government_id'] | 9938 |
|---|---|
| ['email', 'phone'] | 8952 |
| ['email', 'phone', 'reviews'] | 6623 |
| Other values (544) |
| Value | Count | Frequency (%) | |
| ['email', 'phone', 'reviews', 'jumio', 'government_id'] | 9938 | 11.7% | |
| ['email', 'phone'] | 8952 | 10.5% | |
| ['email', 'phone', 'reviews'] | 6623 | 7.8% | |
| ['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] | 6250 | 7.3% | |
| ['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id'] | 5077 | 6.0% | |
| ['email', 'phone', 'reviews', 'jumio', 'government_id', 'work_email'] | 3384 | 4.0% | |
| ['email', 'phone', 'facebook', 'reviews', 'jumio', 'government_id'] | 3347 | 3.9% | |
| ['email', 'phone', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] | 2823 | 3.3% | |
| ['email', 'phone', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] | 2741 | 3.2% | |
| ['phone'] | 2460 | 2.9% | |
| Other values (537) | 33677 | 39.5% |
| Max length | 170 |
|---|---|
| Mean length | 66.24462608 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
id
Highly correlated
This variable is highly correlated with df_index and should be ignored for analysis
| Correlation | 0.9932492122 |
|---|
instant_bookable
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| f | |
|---|---|
| t | |
| (Missing) | 1 |
| Value | Count | Frequency (%) | |
| f | 48092 | 56.4% | |
| t | 37180 | 43.6% | |
| (Missing) | 1 | < 0.1% |
is_location_exact
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| t | |
|---|---|
| f | |
| (Missing) | 1 |
| Value | Count | Frequency (%) | |
| t | 52899 | 62.0% | |
| f | 32373 | 38.0% | |
| (Missing) | 1 | < 0.1% |
last_review
Categorical
| Distinct count | 1779 |
|---|---|
| Unique (%) | 2.1% |
| Missing (%) | 24.6% |
| Missing (n) | 21004 |
| 2019-08-26 | 1312 |
|---|---|
| 2019-09-01 | 1258 |
| 2019-09-08 | 1148 |
| Other values (1775) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 2019-08-26 | 1312 | 1.5% | |
| 2019-09-01 | 1258 | 1.5% | |
| 2019-09-08 | 1148 | 1.3% | |
| 2019-08-25 | 1137 | 1.3% | |
| 2019-08-27 | 1086 | 1.3% | |
| 2019-08-31 | 1070 | 1.3% | |
| 2019-08-30 | 969 | 1.1% | |
| 2019-08-18 | 954 | 1.1% | |
| 2019-09-12 | 849 | 1.0% | |
| 2019-08-28 | 780 | 0.9% | |
| Other values (1768) | 53706 | 63.0% | |
| (Missing) | 21004 | 24.6% |
| Max length | 10 |
|---|---|
| Mean length | 8.275796559 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
last_scraped
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2019-09-15 | |
|---|---|
| 2019-09-14 | |
| 2019-09-30 | 3 |
| Value | Count | Frequency (%) | |
| 2019-09-15 | 66578 | 78.1% | |
| 2019-09-14 | 18692 | 21.9% | |
| 2019-09-30 | 3 | < 0.1% |
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
latitude
Numeric
| Distinct count | 20695 |
|---|---|
| Unique (%) | 24.3% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 51.50971696 |
|---|---|
| Minimum | 51.29479 |
| Maximum | 51.68169 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 51.29479 |
|---|---|
| 5-th percentile | 51.4253 |
| Q1 | 51.48551 |
| Median | 51.51403 |
| Q3 | 51.53747 |
| 95-th percentile | 51.58418 |
| Maximum | 51.68169 |
| Range | 0.3869 |
| Interquartile range | 0.05196 |
Descriptive statistics
| Standard deviation | 0.0462845385 |
|---|---|
| Coef of variation | 0.0008985593637 |
| Kurtosis | 0.9700292581 |
| Mean | 51.50971696 |
| MAD | 0.0350742059 |
| Skewness | -0.3263567874 |
| Sum | 4392336.585 |
| Variance | 0.002142258504 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 51.51571 | 27 | < 0.1% | |
| 51.51375 | 24 | < 0.1% | |
| 51.52559 | 23 | < 0.1% | |
| 51.52476 | 22 | < 0.1% | |
| 51.51382 | 22 | < 0.1% | |
| 51.49133 | 21 | < 0.1% | |
| 51.5129 | 21 | < 0.1% | |
| 51.51307 | 21 | < 0.1% | |
| 51.51343 | 21 | < 0.1% | |
| 51.5141 | 21 | < 0.1% | |
| Other values (20684) | 85049 | 99.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 51.29479 | 1 | < 0.1% | |
| 51.29733 | 1 | < 0.1% | |
| 51.29893 | 1 | < 0.1% | |
| 51.29911 | 1 | < 0.1% | |
| 51.29914 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 51.68169 | 1 | < 0.1% | |
| 51.6792 | 1 | < 0.1% | |
| 51.67651 | 1 | < 0.1% | |
| 51.67566 | 1 | < 0.1% | |
| 51.67501 | 1 | < 0.1% |
longitude
Numeric
| Distinct count | 32024 |
|---|---|
| Unique (%) | 37.6% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -0.1279442907 |
|---|---|
| Minimum | -0.50916 |
| Maximum | 0.28774 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -0.50916 |
|---|---|
| 5-th percentile | -0.28205 |
| Q1 | -0.1879925 |
| Median | -0.12592 |
| Q3 | -0.0699875 |
| 95-th percentile | 0.01455 |
| Maximum | 0.28774 |
| Range | 0.7969 |
| Interquartile range | 0.118005 |
Descriptive statistics
| Standard deviation | 0.09237933599 |
|---|---|
| Coef of variation | -0.7220278096 |
| Kurtosis | 1.215919743 |
| Mean | -0.1279442907 |
| MAD | 0.07100705557 |
| Skewness | -0.1181528542 |
| Sum | -10910.06556 |
| Variance | 0.008533941718 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| -0.07057 | 14 | < 0.1% | |
| -0.09728 | 13 | < 0.1% | |
| -0.0718 | 13 | < 0.1% | |
| -0.13649 | 13 | < 0.1% | |
| -0.19517 | 13 | < 0.1% | |
| -0.13745 | 13 | < 0.1% | |
| -0.14027 | 12 | < 0.1% | |
| -0.13472 | 12 | < 0.1% | |
| -0.10878 | 12 | < 0.1% | |
| -0.1404 | 12 | < 0.1% | |
| Other values (32013) | 85145 | 99.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -0.50916 | 1 | < 0.1% | |
| -0.5013 | 1 | < 0.1% | |
| -0.49625 | 1 | < 0.1% | |
| -0.49582 | 1 | < 0.1% | |
| -0.48786 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.28774 | 1 | < 0.1% | |
| 0.28539 | 1 | < 0.1% | |
| 0.28429 | 1 | < 0.1% | |
| 0.27268 | 1 | < 0.1% | |
| 0.27208 | 1 | < 0.1% |
maximum_nights
Numeric
| Distinct count | 311 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 20127.72094 |
|---|---|
| Minimum | 1 |
| Maximum | 999999999 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 31 |
| Median | 1125 |
| Q3 | 1125 |
| 95-th percentile | 1125 |
| Maximum | 999999999 |
| Range | 999999998 |
| Interquartile range | 1094 |
Descriptive statistics
| Standard deviation | 3883047.211 |
|---|---|
| Coef of variation | 192.9203621 |
| Kurtosis | 55498.88658 |
| Mean | 20127.72094 |
| MAD | 38812.75849 |
| Skewness | 229.4506278 |
| Sum | 1716331020 |
| Variance | 1.507805565e+13 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1125 | 50694 | 59.4% | |
| 30 | 4580 | 5.4% | |
| 14 | 3115 | 3.7% | |
| 7 | 2389 | 2.8% | |
| 90 | 2336 | 2.7% | |
| 365 | 1629 | 1.9% | |
| 60 | 1503 | 1.8% | |
| 10 | 1398 | 1.6% | |
| 21 | 1211 | 1.4% | |
| 1124 | 1142 | 1.3% | |
| Other values (300) | 15275 | 17.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 149 | 0.2% | |
| 2 | 313 | 0.4% | |
| 3 | 576 | 0.7% | |
| 4 | 617 | 0.7% | |
| 5 | 918 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 999999999 | 1 | < 0.1% | |
| 524855552 | 1 | < 0.1% | |
| 99999999 | 1 | < 0.1% | |
| 10000000 | 1 | < 0.1% | |
| 9999999 | 1 | < 0.1% |
minimum_nights
Numeric
| Distinct count | 110 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.120402946 |
|---|---|
| Minimum | 1 |
| Maximum | 1125 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 3 |
| 95-th percentile | 7 |
| Maximum | 1125 |
| Range | 1124 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 15.65286387 |
|---|---|
| Coef of variation | 3.798867266 |
| Kurtosis | 1754.601583 |
| Mean | 4.120402946 |
| MAD | 3.728571011 |
| Skewness | 31.59665823 |
| Sum | 351355 |
| Variance | 245.0121474 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1 | 28511 | 33.4% | |
| 2 | 25480 | 29.9% | |
| 3 | 13779 | 16.2% | |
| 4 | 4482 | 5.3% | |
| 5 | 4334 | 5.1% | |
| 7 | 3525 | 4.1% | |
| 6 | 1041 | 1.2% | |
| 14 | 804 | 0.9% | |
| 10 | 535 | 0.6% | |
| 30 | 490 | 0.6% | |
| Other values (99) | 2291 | 2.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 28511 | 33.4% | |
| 2 | 25480 | 29.9% | |
| 3 | 13779 | 16.2% | |
| 4 | 4482 | 5.3% | |
| 5 | 4334 | 5.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1125 | 1 | < 0.1% | |
| 1124 | 2 | < 0.1% | |
| 1000 | 2 | < 0.1% | |
| 999 | 1 | < 0.1% | |
| 900 | 1 | < 0.1% |
monthly_price
Categorical
| Distinct count | 872 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | 94.0% |
| Missing (n) | 80144 |
| $2,000.00 | 166 |
|---|---|
| $1,000.00 | 157 |
| $1,200.00 | 154 |
| Other values (868) | 4652 |
| (Missing) |
| Value | Count | Frequency (%) | |
| $2,000.00 | 166 | 0.2% | |
| $1,000.00 | 157 | 0.2% | |
| $1,200.00 | 154 | 0.2% | |
| $800.00 | 138 | 0.2% | |
| $1,500.00 | 137 | 0.2% | |
| $900.00 | 127 | 0.1% | |
| $2,500.00 | 123 | 0.1% | |
| $3,000.00 | 116 | 0.1% | |
| $1,400.00 | 105 | 0.1% | |
| $1,800.00 | 104 | 0.1% | |
| Other values (861) | 3802 | 4.5% | |
| (Missing) | 80144 | 94.0% |
| Max length | 10 |
|---|---|
| Mean length | 3.327313452 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
neighbourhood
Categorical
| Distinct count | 150 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| City of Westminster | 5583 |
|---|---|
| LB of Tower Hamlets | 4609 |
| LB of Hackney | 3788 |
| Other values (146) |
| Value | Count | Frequency (%) | |
| City of Westminster | 5583 | 6.5% | |
| LB of Tower Hamlets | 4609 | 5.4% | |
| LB of Hackney | 3788 | 4.4% | |
| LB of Islington | 3767 | 4.4% | |
| LB of Camden | 3096 | 3.6% | |
| LB of Southwark | 2562 | 3.0% | |
| LB of Wandsworth | 2556 | 3.0% | |
| RB of Kensington and Chelsea | 2516 | 3.0% | |
| LB of Brent | 2497 | 2.9% | |
| LB of Lambeth | 2455 | 2.9% | |
| Other values (139) | 51843 | 60.8% |
| Max length | 28 |
|---|---|
| Mean length | 14.04991029 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
neighbourhood_cleansed
Categorical
| Distinct count | 34 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Westminster | 9809 |
|---|---|
| Tower Hamlets | 8198 |
| Hackney | 6240 |
| Other values (30) |
| Value | Count | Frequency (%) | |
| Westminster | 9809 | 11.5% | |
| Tower Hamlets | 8198 | 9.6% | |
| Hackney | 6240 | 7.3% | |
| Kensington and Chelsea | 6023 | 7.1% | |
| Camden | 5962 | 7.0% | |
| Islington | 5131 | 6.0% | |
| Southwark | 4888 | 5.7% | |
| Lambeth | 4856 | 5.7% | |
| Wandsworth | 4353 | 5.1% | |
| Hammersmith and Fulham | 4190 | 4.9% | |
| Other values (23) | 25622 | 30.0% |
| Max length | 22 |
|---|---|
| Mean length | 10.62498094 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
number_of_reviews
Numeric
| Distinct count | 412 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 16.81730228 |
|---|---|
| Minimum | 0 |
| Maximum | 690 |
| Zeros (%) | 24.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 4 |
| Q3 | 17 |
| 95-th percentile | 77 |
| Maximum | 690 |
| Range | 690 |
| Interquartile range | 16 |
Descriptive statistics
| Standard deviation | 35.67412186 |
|---|---|
| Coef of variation | 2.121274939 |
| Kurtosis | 38.66970663 |
| Mean | 16.81730228 |
| MAD | 19.77222867 |
| Skewness | 5.033409711 |
| Sum | 1434045 |
| Variance | 1272.642971 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 21003 | 24.6% | |
| 1 | 9291 | 10.9% | |
| 2 | 5929 | 7.0% | |
| 3 | 4538 | 5.3% | |
| 4 | 3622 | 4.2% | |
| 5 | 2873 | 3.4% | |
| 6 | 2480 | 2.9% | |
| 7 | 2087 | 2.4% | |
| 8 | 1914 | 2.2% | |
| 9 | 1698 | 2.0% | |
| Other values (401) | 29837 | 35.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 21003 | 24.6% | |
| 1 | 9291 | 10.9% | |
| 2 | 5929 | 7.0% | |
| 3 | 4538 | 5.3% | |
| 4 | 3622 | 4.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 690 | 1 | < 0.1% | |
| 633 | 1 | < 0.1% | |
| 612 | 1 | < 0.1% | |
| 595 | 1 | < 0.1% | |
| 591 | 1 | < 0.1% |
number_of_reviews_ltm
Numeric
| Distinct count | 147 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.613519092 |
|---|---|
| Minimum | 0 |
| Maximum | 231 |
| Zeros (%) | 41.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 8 |
| 95-th percentile | 31 |
| Maximum | 231 |
| Range | 231 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 12.70142361 |
|---|---|
| Coef of variation | 1.920524222 |
| Kurtosis | 20.65124055 |
| Mean | 6.613519092 |
| MAD | 7.886865158 |
| Skewness | 3.753960323 |
| Sum | 563948 |
| Variance | 161.3261617 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 35468 | 41.6% | |
| 1 | 8370 | 9.8% | |
| 2 | 5441 | 6.4% | |
| 3 | 4130 | 4.8% | |
| 4 | 3380 | 4.0% | |
| 5 | 2745 | 3.2% | |
| 6 | 2318 | 2.7% | |
| 7 | 2023 | 2.4% | |
| 8 | 1737 | 2.0% | |
| 9 | 1584 | 1.9% | |
| Other values (136) | 18076 | 21.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 35468 | 41.6% | |
| 1 | 8370 | 9.8% | |
| 2 | 5441 | 6.4% | |
| 3 | 4130 | 4.8% | |
| 4 | 3380 | 4.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 231 | 1 | < 0.1% | |
| 200 | 1 | < 0.1% | |
| 185 | 1 | < 0.1% | |
| 182 | 1 | < 0.1% | |
| 180 | 1 | < 0.1% |
price
Categorical
| Distinct count | 888 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| $50.00 | 3107 |
|---|---|
| $100.00 | 3066 |
| $40.00 | 2796 |
| Other values (884) |
| Value | Count | Frequency (%) | |
| $50.00 | 3107 | 3.6% | |
| $100.00 | 3066 | 3.6% | |
| $40.00 | 2796 | 3.3% | |
| $35.00 | 2531 | 3.0% | |
| $30.00 | 2365 | 2.8% | |
| $120.00 | 2360 | 2.8% | |
| $45.00 | 2303 | 2.7% | |
| $150.00 | 2280 | 2.7% | |
| $60.00 | 2245 | 2.6% | |
| $80.00 | 2226 | 2.6% | |
| Other values (877) | 59993 | 70.4% |
| Max length | 10 |
|---|---|
| Mean length | 6.420566885 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
property_type
Categorical
| Distinct count | 44 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Apartment | |
|---|---|
| House | |
| Townhouse | 2995 |
| Other values (40) | 7924 |
| Value | Count | Frequency (%) | |
| Apartment | 56401 | 66.1% | |
| House | 17952 | 21.1% | |
| Townhouse | 2995 | 3.5% | |
| Condominium | 2716 | 3.2% | |
| Serviced apartment | 1719 | 2.0% | |
| Loft | 739 | 0.9% | |
| Bed and breakfast | 647 | 0.8% | |
| Guest suite | 364 | 0.4% | |
| Guesthouse | 305 | 0.4% | |
| Boutique hotel | 242 | 0.3% | |
| Other values (33) | 1192 | 1.4% |
| Max length | 29 |
|---|---|
| Mean length | 8.412592497 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
require_guest_phone_verification
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| f | |
|---|---|
| t | 1429 |
| (Missing) | 1 |
| Value | Count | Frequency (%) | |
| f | 83843 | 98.3% | |
| t | 1429 | 1.7% | |
| (Missing) | 1 | < 0.1% |
require_guest_profile_picture
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| f | |
|---|---|
| t | 859 |
| (Missing) | 1 |
| Value | Count | Frequency (%) | |
| f | 84413 | 99.0% | |
| t | 859 | 1.0% | |
| (Missing) | 1 | < 0.1% |
requires_license
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| f | |
|---|---|
| t | 3 |
| (Missing) | 1 |
| Value | Count | Frequency (%) | |
| f | 85269 | > 99.9% | |
| t | 3 | < 0.1% | |
| (Missing) | 1 | < 0.1% |
review_scores_accuracy
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 26.7% |
| Missing (n) | 22734 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.500311805 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.9994301354 |
|---|---|
| Coef of variation | 0.1051997193 |
| Kurtosis | 19.01700441 |
| Mean | 9.500311805 |
| MAD | 0.6788645128 |
| Skewness | -3.648096413 |
| Sum | 594140 |
| Variance | 0.9988605955 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 10 | 42482 | 49.8% | |
| 9 | 14163 | 16.6% | |
| 8 | 3716 | 4.4% | |
| 7 | 802 | 0.9% | |
| 6 | 761 | 0.9% | |
| 2 | 305 | 0.4% | |
| 4 | 189 | 0.2% | |
| 5 | 108 | 0.1% | |
| 3 | 13 | < 0.1% | |
| (Missing) | 22734 | 26.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 305 | 0.4% | |
| 3 | 13 | < 0.1% | |
| 4 | 189 | 0.2% | |
| 5 | 108 | 0.1% | |
| 6 | 761 | 0.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 42482 | 49.8% | |
| 9 | 14163 | 16.6% | |
| 8 | 3716 | 4.4% | |
| 7 | 802 | 0.9% | |
| 6 | 761 | 0.9% |
review_scores_checkin
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 26.7% |
| Missing (n) | 22782 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.624041862 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 10 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.9068226974 |
|---|---|
| Coef of variation | 0.09422472495 |
| Kurtosis | 26.23327385 |
| Mean | 9.624041862 |
| MAD | 0.5711897319 |
| Skewness | -4.336635281 |
| Sum | 601416 |
| Variance | 0.8223274045 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 10 | 47471 | 55.7% | |
| 9 | 10728 | 12.6% | |
| 8 | 2616 | 3.1% | |
| 7 | 616 | 0.7% | |
| 6 | 570 | 0.7% | |
| 2 | 263 | 0.3% | |
| 4 | 147 | 0.2% | |
| 5 | 70 | 0.1% | |
| 3 | 10 | < 0.1% | |
| (Missing) | 22782 | 26.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 263 | 0.3% | |
| 3 | 10 | < 0.1% | |
| 4 | 147 | 0.2% | |
| 5 | 70 | 0.1% | |
| 6 | 570 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 47471 | 55.7% | |
| 9 | 10728 | 12.6% | |
| 8 | 2616 | 3.1% | |
| 7 | 616 | 0.7% | |
| 6 | 570 | 0.7% |
review_scores_cleanliness
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 26.6% |
| Missing (n) | 22721 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.261494437 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 9 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.149805624 |
|---|---|
| Coef of variation | 0.1241490379 |
| Kurtosis | 10.79236777 |
| Mean | 9.261494437 |
| MAD | 0.8176075469 |
| Skewness | -2.714264208 |
| Sum | 579325 |
| Variance | 1.322052973 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 10 | 34626 | 40.6% | |
| 9 | 17642 | 20.7% | |
| 8 | 6598 | 7.7% | |
| 7 | 1669 | 2.0% | |
| 6 | 1138 | 1.3% | |
| 2 | 349 | 0.4% | |
| 4 | 310 | 0.4% | |
| 5 | 197 | 0.2% | |
| 3 | 23 | < 0.1% | |
| (Missing) | 22721 | 26.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 349 | 0.4% | |
| 3 | 23 | < 0.1% | |
| 4 | 310 | 0.4% | |
| 5 | 197 | 0.2% | |
| 6 | 1138 | 1.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 34626 | 40.6% | |
| 9 | 17642 | 20.7% | |
| 8 | 6598 | 7.7% | |
| 7 | 1669 | 2.0% | |
| 6 | 1138 | 1.3% |
review_scores_communication
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 26.7% |
| Missing (n) | 22727 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.64827487 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 10 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.9056841568 |
|---|---|
| Coef of variation | 0.09387006164 |
| Kurtosis | 27.68830452 |
| Mean | 9.64827487 |
| MAD | 0.5499522087 |
| Skewness | -4.519780247 |
| Sum | 603461 |
| Variance | 0.8202637918 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 10 | 48898 | 57.3% | |
| 9 | 9561 | 11.2% | |
| 8 | 2414 | 2.8% | |
| 7 | 588 | 0.7% | |
| 6 | 568 | 0.7% | |
| 2 | 269 | 0.3% | |
| 4 | 156 | 0.2% | |
| 5 | 79 | 0.1% | |
| 3 | 13 | < 0.1% | |
| (Missing) | 22727 | 26.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 269 | 0.3% | |
| 3 | 13 | < 0.1% | |
| 4 | 156 | 0.2% | |
| 5 | 79 | 0.1% | |
| 6 | 568 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 48898 | 57.3% | |
| 9 | 9561 | 11.2% | |
| 8 | 2414 | 2.8% | |
| 7 | 588 | 0.7% | |
| 6 | 568 | 0.7% |
review_scores_location
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 26.7% |
| Missing (n) | 22781 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.526899443 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.830363656 |
|---|---|
| Coef of variation | 0.08715990558 |
| Kurtosis | 19.62898166 |
| Mean | 9.526899443 |
| MAD | 0.6150791756 |
| Skewness | -3.34135892 |
| Sum | 595355 |
| Variance | 0.6895038011 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 10 | 40623 | 47.6% | |
| 9 | 16972 | 19.9% | |
| 8 | 3649 | 4.3% | |
| 6 | 526 | 0.6% | |
| 7 | 466 | 0.5% | |
| 2 | 142 | 0.2% | |
| 4 | 85 | 0.1% | |
| 5 | 28 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| (Missing) | 22781 | 26.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 142 | 0.2% | |
| 3 | 1 | < 0.1% | |
| 4 | 85 | 0.1% | |
| 5 | 28 | < 0.1% | |
| 6 | 526 | 0.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 40623 | 47.6% | |
| 9 | 16972 | 19.9% | |
| 8 | 3649 | 4.3% | |
| 7 | 466 | 0.5% | |
| 6 | 526 | 0.6% |
review_scores_rating
Numeric
| Distinct count | 62 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 26.6% |
| Missing (n) | 22683 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 92.51442722 |
|---|---|
| Minimum | 20 |
| Maximum | 100 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 76 |
| Q1 | 90 |
| Median | 96 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 80 |
| Interquartile range | 10 |
Descriptive statistics
| Standard deviation | 10.25770956 |
|---|---|
| Coef of variation | 0.1108768639 |
| Kurtosis | 14.52539377 |
| Mean | 92.51442722 |
| MAD | 6.857333534 |
| Skewness | -3.098447603 |
| Sum | 5790478 |
| Variance | 105.2206054 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 100 | 17907 | 21.0% | |
| 98 | 3877 | 4.5% | |
| 97 | 3731 | 4.4% | |
| 96 | 3640 | 4.3% | |
| 93 | 3623 | 4.2% | |
| 90 | 3364 | 3.9% | |
| 95 | 3343 | 3.9% | |
| 80 | 3303 | 3.9% | |
| 99 | 2505 | 2.9% | |
| 94 | 2390 | 2.8% | |
| Other values (51) | 14907 | 17.5% | |
| (Missing) | 22683 | 26.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 20 | 295 | 0.3% | |
| 30 | 9 | < 0.1% | |
| 32 | 1 | < 0.1% | |
| 33 | 1 | < 0.1% | |
| 40 | 223 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 17907 | 21.0% | |
| 99 | 2505 | 2.9% | |
| 98 | 3877 | 4.5% | |
| 97 | 3731 | 4.4% | |
| 96 | 3640 | 4.3% |
review_scores_value
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 26.7% |
| Missing (n) | 22782 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.26541422 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.04789939 |
|---|---|
| Coef of variation | 0.1130979538 |
| Kurtosis | 13.0989518 |
| Mean | 9.26541422 |
| MAD | 0.7395581729 |
| Skewness | -2.846842154 |
| Sum | 579005 |
| Variance | 1.098093131 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 10 | 31457 | 36.9% | |
| 9 | 22279 | 26.1% | |
| 8 | 6050 | 7.1% | |
| 7 | 1101 | 1.3% | |
| 6 | 929 | 1.1% | |
| 2 | 288 | 0.3% | |
| 4 | 234 | 0.3% | |
| 5 | 136 | 0.2% | |
| 3 | 17 | < 0.1% | |
| (Missing) | 22782 | 26.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 288 | 0.3% | |
| 3 | 17 | < 0.1% | |
| 4 | 234 | 0.3% | |
| 5 | 136 | 0.2% | |
| 6 | 929 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 31457 | 36.9% | |
| 9 | 22279 | 26.1% | |
| 8 | 6050 | 7.1% | |
| 7 | 1101 | 1.3% | |
| 6 | 929 | 1.1% |
reviews_per_month
Numeric
| Distinct count | 932 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 24.6% |
| Missing (n) | 21004 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.178750253 |
|---|---|
| Minimum | 0.01 |
| Maximum | 48.21 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.05 |
| Q1 | 0.24 |
| Median | 0.74 |
| Q3 | 1.6 |
| 95-th percentile | 3.94 |
| Maximum | 48.21 |
| Range | 48.2 |
| Interquartile range | 1.36 |
Descriptive statistics
| Standard deviation | 1.375763779 |
|---|---|
| Coef of variation | 1.167137632 |
| Kurtosis | 30.11427919 |
| Mean | 1.178750253 |
| MAD | 0.9649094663 |
| Skewness | 2.981539061 |
| Sum | 75757.1 |
| Variance | 1.892725976 |
| Memory size | 666.3 KiB |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1 | 1889 | 2.2% | |
| 0.04 | 1066 | 1.3% | |
| 0.08 | 1022 | 1.2% | |
| 0.05 | 954 | 1.1% | |
| 0.07 | 923 | 1.1% | |
| 0.02 | 921 | 1.1% | |
| 0.03 | 896 | 1.1% | |
| 0.12 | 803 | 0.9% | |
| 0.06 | 800 | 0.9% | |
| 0.1 | 714 | 0.8% | |
| Other values (921) | 54281 | 63.7% | |
| (Missing) | 21004 | 24.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.01 | 34 | < 0.1% | |
| 0.02 | 921 | 1.1% | |
| 0.03 | 896 | 1.1% | |
| 0.04 | 1066 | 1.3% | |
| 0.05 | 954 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 48.21 | 1 | < 0.1% | |
| 24.39 | 1 | < 0.1% | |
| 15.52 | 1 | < 0.1% | |
| 15.17 | 1 | < 0.1% | |
| 14.72 | 1 | < 0.1% |
room_type
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 1 |
| Entire home/apt | |
|---|---|
| Private room | |
| Hotel room | 1510 |
| Value | Count | Frequency (%) | |
| Entire home/apt | 47115 | 55.3% | |
| Private room | 36013 | 42.2% | |
| Hotel room | 1510 | 1.8% | |
| Shared room | 634 | 0.7% | |
| (Missing) | 1 | < 0.1% |
| Max length | 15 |
|---|---|
| Mean length | 13.61460251 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
security_deposit
Categorical
| Distinct count | 380 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 34.8% |
| Missing (n) | 29653 |
| $0.00 | |
|---|---|
| $100.00 | |
| $200.00 | 4997 |
| Other values (376) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| $0.00 | 19620 | 23.0% | |
| $100.00 | 6014 | 7.1% | |
| $200.00 | 4997 | 5.9% | |
| $250.00 | 3644 | 4.3% | |
| $300.00 | 3322 | 3.9% | |
| $500.00 | 3283 | 3.8% | |
| $150.00 | 2904 | 3.4% | |
| $85.00 | 1958 | 2.3% | |
| $495.00 | 1324 | 1.6% | |
| $350.00 | 1017 | 1.2% | |
| Other values (369) | 7537 | 8.8% | |
| (Missing) | 29653 | 34.8% |
| Max length | 10 |
|---|---|
| Mean length | 5.137992096 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
weekly_price
Categorical
| Distinct count | 690 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 91.6% |
| Missing (n) | 78082 |
| $300.00 | 295 |
|---|---|
| $500.00 | 277 |
| $250.00 | 255 |
| Other values (686) | 6364 |
| (Missing) |
| Value | Count | Frequency (%) | |
| $300.00 | 295 | 0.3% | |
| $500.00 | 277 | 0.3% | |
| $250.00 | 255 | 0.3% | |
| $350.00 | 251 | 0.3% | |
| $600.00 | 248 | 0.3% | |
| $200.00 | 231 | 0.3% | |
| $400.00 | 212 | 0.2% | |
| $700.00 | 182 | 0.2% | |
| $450.00 | 181 | 0.2% | |
| $550.00 | 147 | 0.2% | |
| Other values (679) | 4912 | 5.8% | |
| (Missing) | 78082 | 91.6% |
| Max length | 9 |
|---|---|
| Mean length | 3.357510584 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
First rows
| accommodates | amenities | availability_30 | availability_365 | availability_60 | availability_90 | bathrooms | bed_type | bedrooms | beds | calculated_host_listings_count | calculated_host_listings_count_entire_homes | calculated_host_listings_count_private_rooms | calculated_host_listings_count_shared_rooms | cancellation_policy | cleaning_fee | df_index | experiences_offered | extra_people | first_review | guests_included | host_has_profile_pic | host_identity_verified | host_is_superhost | host_since | host_verifications | id | instant_bookable | is_location_exact | last_review | last_scraped | latitude | longitude | maximum_nights | minimum_nights | monthly_price | neighbourhood | neighbourhood_cleansed | number_of_reviews | number_of_reviews_ltm | price | property_type | require_guest_phone_verification | require_guest_profile_picture | requires_license | review_scores_accuracy | review_scores_checkin | review_scores_cleanliness | review_scores_communication | review_scores_location | review_scores_rating | review_scores_value | reviews_per_month | room_type | security_deposit | weekly_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 4.0 | {TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Pack ’n Play/travel crib","Hot water","Long term stays allowed"} | 19.0 | 344.0 | 42.0 | 72.0 | 1.0 | Real Bed | 1.0 | 1.0 | 2.0 | 2.0 | 0.0 | 0.0 | strict_14_with_grace_period | $30.00 | 0 | family | $20.00 | 2010-03-21 | 2.0 | t | t | t | 2009-10-03 | ['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id'] | 11551.0 | t | t | 2019-07-10 | 2019-09-15 | 51.46225 | -0.11732 | 180.0 | 2.0 | $2,350.00 | Brixton | Lambeth | 184.0 | 1.0 | $88.00 | Apartment | t | f | f | 9.0 | 10.0 | 9.0 | 10.0 | 9.0 | 92.0 | 9.0 | 1.59 | Entire home/apt | $400.00 | $645.00 |
| 1 | 2.0 | {TV,"Cable TV",Wifi,Kitchen,"Paid parking off premises","Smoking allowed","Free street parking","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"Children’s books and toys","Babysitter recommendations",Crib,"Pack ’n Play/travel crib","Room-darkening shades","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection","Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Luggage dropoff allowed","Long term stays allowed","No stairs or steps to enter","Wide entrance","Extra space around bed","Accessible-height bed","No stairs or steps to enter","Wide doorway to guest bathroom","Bathtub with bath chair","Accessible-height toilet","Host greets you","Handheld shower head","Roll-in shower"} | 18.0 | 353.0 | 48.0 | 78.0 | 1.0 | Real Bed | 1.0 | 0.0 | 3.0 | 1.0 | 2.0 | 0.0 | moderate | $15.00 | 1 | business | $15.00 | 2010-08-18 | 1.0 | t | f | f | 2009-11-16 | ['email', 'phone', 'facebook', 'reviews'] | 13913.0 | f | t | 2019-06-10 | 2019-09-15 | 51.56802 | -0.11121 | 29.0 | 1.0 | $1,176.00 | LB of Islington | Islington | 16.0 | 2.0 | $65.00 | Apartment | f | f | f | 9.0 | 9.0 | 10.0 | 10.0 | 9.0 | 96.0 | 9.0 | 0.14 | Private room | $100.00 | $333.00 |
| 2 | 2.0 | {TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water",Microwave,"Coffee maker","Dishes and silverware","Luggage dropoff allowed","Long term stays allowed",Other} | 8.0 | 114.0 | 8.0 | 8.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | strict_14_with_grace_period | $50.00 | 2 | romantic | $0.00 | 2009-12-21 | 2.0 | t | t | t | 2009-12-05 | ['email', 'phone', 'reviews', 'jumio', 'government_id'] | 15400.0 | t | t | 2019-08-27 | 2019-09-15 | 51.48796 | -0.16898 | 50.0 | 30.0 | $2,250.00 | Chelsea | Kensington and Chelsea | 87.0 | 6.0 | $100.00 | Apartment | t | t | f | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 96.0 | 9.0 | 0.73 | Entire home/apt | $150.00 | $600.00 |
| 3 | 6.0 | {TV,Wifi,Kitchen,"Paid parking off premises",Elevator,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Bed linens",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed"} | 12.0 | 265.0 | 36.0 | 54.0 | 2.0 | Real Bed | 3.0 | 4.0 | 15.0 | 15.0 | 0.0 | 0.0 | strict_14_with_grace_period | $65.00 | 3 | none | $10.00 | 2011-03-21 | 4.0 | t | t | t | 2010-01-04 | ['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual', 'work_email'] | 17402.0 | t | t | 2019-06-19 | 2019-09-15 | 51.52098 | -0.14002 | 365.0 | 3.0 | NaN | City of Westminster | Westminster | 41.0 | 5.0 | $300.00 | Apartment | f | f | f | 10.0 | 9.0 | 9.0 | 9.0 | 10.0 | 94.0 | 9.0 | 0.40 | Entire home/apt | $350.00 | $1,378.00 |
| 4 | 2.0 | {TV,"Cable TV",Internet,Wifi,Kitchen,"Free parking on premises","Pets allowed","Pets live on this property","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Long term stays allowed"} | 11.0 | 346.0 | 41.0 | 71.0 | 1.5 | Real Bed | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | moderate | $70.00 | 4 | family | $0.00 | 2010-11-15 | 2.0 | t | t | f | 2009-09-28 | ['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id'] | 24328.0 | f | t | 2019-06-08 | 2019-09-15 | 51.47298 | -0.16376 | 1125.0 | 30.0 | $3,500.00 | LB of Wandsworth | Wandsworth | 93.0 | 1.0 | $175.00 | Townhouse | t | t | f | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 98.0 | 9.0 | 0.86 | Entire home/apt | $250.00 | $1,050.00 |
| 5 | 4.0 | {TV,Wifi,Kitchen,"Free parking on premises",Elevator,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water","Host greets you"} | 0.0 | 147.0 | 24.0 | 54.0 | 1.0 | Real Bed | 2.0 | 2.0 | 1.0 | 1.0 | 0.0 | 0.0 | moderate | $50.00 | 5 | none | $11.00 | 2016-03-05 | 2.0 | t | f | f | 2010-04-03 | ['email', 'phone', 'reviews'] | 25023.0 | t | t | 2019-07-25 | 2019-09-15 | 51.44687 | -0.21874 | 1125.0 | 90.0 | $2,515.00 | LB of Wandsworth | Wandsworth | 31.0 | 5.0 | $65.00 | Apartment | f | f | f | 10.0 | 9.0 | 9.0 | 10.0 | 9.0 | 92.0 | 9.0 | 0.72 | Entire home/apt | $250.00 | $630.00 |
| 6 | 2.0 | {Wifi,Kitchen,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"} | 12.0 | 288.0 | 12.0 | 26.0 | 1.5 | Real Bed | 1.0 | 1.0 | 3.0 | 0.0 | 3.0 | 0.0 | strict_14_with_grace_period | $0.00 | 6 | none | $8.00 | 2010-04-14 | 1.0 | t | f | t | 2010-04-05 | ['email', 'phone', 'reviews', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] | 25123.0 | t | t | 2019-06-28 | 2019-09-15 | 51.57224 | -0.20906 | 1120.0 | 10.0 | $795.00 | LB of Barnet | Barnet | 122.0 | 5.0 | $29.00 | House | f | f | f | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 95.0 | 10.0 | 1.06 | Private room | $100.00 | $195.00 |
| 7 | 4.0 | {TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"High chair","Children’s books and toys",Crib,"Pack ’n Play/travel crib","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Coffee maker",Refrigerator,"Luggage dropoff allowed","Long term stays allowed","Host greets you"} | 13.0 | 339.0 | 34.0 | 64.0 | 1.0 | Real Bed | 1.0 | 3.0 | 3.0 | 3.0 | 0.0 | 0.0 | strict_14_with_grace_period | $75.00 | 7 | none | $15.00 | 2010-11-02 | 3.0 | t | t | f | 2010-04-19 | ['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] | 26223.0 | t | t | 2019-07-22 | 2019-09-15 | 51.54168 | -0.10207 | 365.0 | 3.0 | $2,747.00 | LB of Islington | Islington | 63.0 | 9.0 | $147.00 | Apartment | f | f | f | 8.0 | 9.0 | 9.0 | 9.0 | 9.0 | 85.0 | 8.0 | 0.58 | Entire home/apt | $100.00 | $727.00 |
| 8 | 2.0 | {TV,Wifi,Kitchen,"Paid parking off premises",Breakfast,Heating,Washer,"Smoke detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50","Hot water",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Garden or backyard","Host greets you"} | 1.0 | 336.0 | 31.0 | 61.0 | 1.5 | Real Bed | 1.0 | 1.0 | 2.0 | 0.0 | 2.0 | 0.0 | strict_14_with_grace_period | $10.00 | 8 | none | $12.00 | 2010-07-01 | 1.0 | t | t | t | 2010-05-29 | ['email', 'phone', 'facebook', 'reviews', 'jumio', 'offline_government_id', 'government_id'] | 31361.0 | f | t | 2019-06-30 | 2019-09-15 | 51.53484 | 0.02707 | 30.0 | 1.0 | $868.00 | LB of Newham | Newham | 115.0 | 10.0 | $34.00 | Townhouse | t | t | f | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 97.0 | 10.0 | 1.03 | Private room | NaN | $231.00 |
| 9 | 2.0 | {Wifi,Kitchen,"Pets live on this property",Cat(s),"Free street parking",Heating,Washer,Dryer,"Smoke detector",Essentials,"Self check-in","Building staff","Hot water"} | 30.0 | 365.0 | 60.0 | 90.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 0.0 | 1.0 | 0.0 | flexible | NaN | 9 | none | $0.00 | 2010-10-16 | 1.0 | t | t | f | 2010-06-14 | ['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id'] | 33332.0 | f | t | 2019-05-26 | 2019-09-15 | 51.46507 | -0.32421 | 21.0 | 1.0 | NaN | LB of Hounslow | Hounslow | 5.0 | 2.0 | $100.00 | House | f | f | f | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | 88.0 | 8.0 | 0.05 | Private room | NaN | NaN |
Last rows
| accommodates | amenities | availability_30 | availability_365 | availability_60 | availability_90 | bathrooms | bed_type | bedrooms | beds | calculated_host_listings_count | calculated_host_listings_count_entire_homes | calculated_host_listings_count_private_rooms | calculated_host_listings_count_shared_rooms | cancellation_policy | cleaning_fee | df_index | experiences_offered | extra_people | first_review | guests_included | host_has_profile_pic | host_identity_verified | host_is_superhost | host_since | host_verifications | id | instant_bookable | is_location_exact | last_review | last_scraped | latitude | longitude | maximum_nights | minimum_nights | monthly_price | neighbourhood | neighbourhood_cleansed | number_of_reviews | number_of_reviews_ltm | price | property_type | require_guest_phone_verification | require_guest_profile_picture | requires_license | review_scores_accuracy | review_scores_checkin | review_scores_cleanliness | review_scores_communication | review_scores_location | review_scores_rating | review_scores_value | reviews_per_month | room_type | security_deposit | weekly_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85263 | 1.0 | {TV,Wifi,"Air conditioning",Kitchen,"Pets allowed",Heating,"Smoke detector",Essentials,"Hair dryer",Iron} | 23.0 | 173.0 | 53.0 | 83.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | flexible | NaN | 85264 | none | $0.00 | NaN | 1.0 | t | f | f | 2019-09-14 | ['phone'] | 38610705.0 | t | f | NaN | 2019-09-15 | 51.56163 | 0.07309 | 1125.0 | 1.0 | NaN | LB of Redbridge | Redbridge | 0.0 | 0.0 | $101.00 | House | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | NaN | NaN |
| 85264 | 4.0 | {TV,Wifi,Kitchen,"Free parking on premises","Pets allowed",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Private entrance","Hot water"} | 0.0 | 307.0 | 2.0 | 32.0 | 1.0 | Real Bed | 2.0 | 2.0 | 1.0 | 1.0 | 0.0 | 0.0 | flexible | NaN | 85265 | none | $0.00 | NaN | 1.0 | t | f | f | 2016-06-12 | ['email', 'phone', 'facebook', 'reviews'] | 38610995.0 | t | f | NaN | 2019-09-15 | 51.42155 | -0.31452 | 1125.0 | 2.0 | NaN | LB of Richmond upon Thames | Richmond upon Thames | 0.0 | 0.0 | $105.00 | House | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | NaN | NaN |
| 85265 | 2.0 | {TV,Wifi,Kitchen,"Free parking on premises",Heating,Washer,"Smoke detector","First aid kit","Fire extinguisher",Essentials,Hangers,Iron,"Laptop friendly workspace","Private entrance","Hot water"} | 23.0 | 80.0 | 44.0 | 66.0 | 1.0 | Real Bed | 1.0 | 2.0 | 1.0 | 1.0 | 0.0 | 0.0 | flexible | NaN | 85266 | none | $0.00 | NaN | 1.0 | t | f | f | 2015-07-16 | ['email', 'phone', 'reviews'] | 38611275.0 | t | f | NaN | 2019-09-15 | 51.42874 | -0.04786 | 1125.0 | 1.0 | NaN | Sydenham | Lewisham | 0.0 | 0.0 | $78.00 | Apartment | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | NaN | NaN |
| 85266 | 2.0 | {Wifi,Kitchen,"Free parking on premises","Pets allowed",Breakfast,Heating,Washer,Essentials,Shampoo,Hangers,"Laptop friendly workspace","Private entrance","Dishes and silverware"} | 13.0 | 73.0 | 43.0 | 73.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | strict_14_with_grace_period | $0.00 | 85267 | none | $0.00 | NaN | 1.0 | t | f | f | 2019-05-05 | ['email', 'phone'] | 38611320.0 | t | t | NaN | 2019-09-15 | 51.62711 | -0.12502 | 1125.0 | 2.0 | NaN | LB of Enfield | Enfield | 0.0 | 0.0 | $30.00 | Apartment | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | $100.00 | NaN |
| 85267 | 2.0 | {Wifi,Kitchen,Washer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 15.0 | 30.0 | 17.0 | 30.0 | 1.0 | Real Bed | 2.0 | 2.0 | 1.0 | 0.0 | 1.0 | 0.0 | flexible | NaN | 85268 | none | $0.00 | NaN | 1.0 | t | f | f | 2012-09-07 | ['phone', 'reviews', 'jumio', 'government_id'] | 38611907.0 | t | f | NaN | 2019-09-15 | 51.51357 | -0.20563 | 1125.0 | 6.0 | NaN | Notting Hill | Kensington and Chelsea | 0.0 | 0.0 | $56.00 | Apartment | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Private room | NaN | NaN |
| 85268 | 5.0 | {TV,Wifi,Kitchen,"Free parking on premises",Heating,Washer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron} | 7.0 | 45.0 | 20.0 | 38.0 | 1.5 | Real Bed | 1.0 | 3.0 | 7.0 | 7.0 | 0.0 | 0.0 | flexible | $40.00 | 85269 | none | $0.00 | NaN | 1.0 | t | f | f | 2018-07-27 | ['email', 'phone', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] | 38612345.0 | t | f | NaN | 2019-09-15 | 51.51383 | -0.27288 | 1125.0 | 2.0 | NaN | LB of Ealing | Ealing | 0.0 | 0.0 | $85.00 | Apartment | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | $0.00 | NaN |
| 85269 | 2.0 | {Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer","Laptop friendly workspace","Self check-in",Lockbox,"Hot water"} | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | Real Bed | 1.0 | 1.0 | 2.0 | 0.0 | 2.0 | 0.0 | flexible | NaN | 85270 | none | $0.00 | NaN | 1.0 | t | f | f | 2017-09-12 | ['email', 'phone', 'jumio', 'offline_government_id', 'government_id'] | 38612360.0 | f | f | NaN | 2019-09-15 | 51.55569 | -0.21251 | 1125.0 | 1.0 | NaN | Hampstead | Camden | 0.0 | 0.0 | $35.00 | Apartment | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Private room | NaN | NaN |
| 85270 | 6.0 | {TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises",Breakfast,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance"} | 23.0 | 173.0 | 53.0 | 83.0 | 4.0 | Real Bed | 3.0 | 3.0 | 1.0 | 1.0 | 0.0 | 0.0 | flexible | NaN | 85271 | none | $0.00 | NaN | 1.0 | t | f | f | 2019-09-14 | ['email', 'phone', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] | 38613001.0 | f | t | NaN | 2019-09-15 | 51.49741 | -0.13901 | 1125.0 | 7.0 | NaN | Westminster | Westminster | 0.0 | 0.0 | $420.00 | Condominium | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | NaN | NaN |
| 85271 | 2.0 | {Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed",Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 10.0 | 233.0 | 23.0 | 53.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 0.0 | 1.0 | 0.0 | flexible | NaN | 85272 | none | $0.00 | NaN | 1.0 | t | f | f | 2019-09-14 | ['email', 'phone'] | 38613420.0 | f | t | NaN | 2019-09-15 | 51.54849 | -0.45504 | 15.0 | 1.0 | NaN | LB of Hillingdon | Hillingdon | 0.0 | 0.0 | $35.00 | House | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Private room | $81.00 | NaN |
| 85272 | 5.0 | {TV,Wifi,Kitchen,Breakfast,Heating,Washer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo} | 2.0 | 32.0 | 15.0 | 32.0 | 1.0 | Real Bed | 2.0 | 2.0 | 3.0 | 2.0 | 1.0 | 0.0 | flexible | NaN | 85273 | none | $0.00 | NaN | 1.0 | t | t | f | 2013-05-03 | ['email', 'phone', 'google', 'reviews', 'jumio', 'government_id'] | 38613719.0 | f | t | NaN | 2019-09-15 | 51.42159 | -0.13139 | 7.0 | 2.0 | NaN | Lower Streatham | Lambeth | 0.0 | 0.0 | $50.00 | Apartment | f | f | f | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | NaN | NaN |